Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 120692 |
| Missing cells | 907331 |
| Missing cells (%) | 22.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 31.3 MiB |
| Average record size in memory | 272.0 B |
Variable types
| Categorical | 14 |
|---|---|
| Numeric | 8 |
| DateTime | 3 |
| Text | 5 |
| Boolean | 2 |
| Unsupported | 1 |
appointment_status is highly overall correlated with business_name and 5 other fields | High correlation |
business_name is highly overall correlated with appointment_status and 3 other fields | High correlation |
cancelled is highly overall correlated with appointment_status and 7 other fields | High correlation |
case_type is highly overall correlated with opened_case_name | High correlation |
concession_type is highly overall correlated with business_name and 3 other fields | High correlation |
customer_type is highly overall correlated with concession_type and 1 other fields | High correlation |
notice is highly overall correlated with cancelled and 1 other fields | High correlation |
opened_case_name is highly overall correlated with case_type and 1 other fields | High correlation |
patient_type is highly overall correlated with appointment_status and 4 other fields | High correlation |
percentage_good_appointments_and_missed_appointments_before_can is highly overall correlated with appointment_status and 4 other fields | High correlation |
referred is highly overall correlated with business_name and 2 other fields | High correlation |
session_left is highly overall correlated with opened_case_name | High correlation |
total_closed_invoices_before_appointemnt is highly overall correlated with total_good_appointments_before_cancelled_appointment | High correlation |
total_cxl_appointments_before_cancelled_appointment is highly overall correlated with appointment_status and 4 other fields | High correlation |
total_good_appointments_before_cancelled_appointment is highly overall correlated with appointment_status and 6 other fields | High correlation |
patient_status is highly imbalanced (87.9%) | Imbalance |
concession_type is highly imbalanced (60.3%) | Imbalance |
title is highly imbalanced (52.7%) | Imbalance |
state is highly imbalanced (82.9%) | Imbalance |
sex is highly imbalanced (62.5%) | Imbalance |
opened_case_name has 35575 (29.5%) missing values | Missing |
total_open_invoices_before_appointemnt has 40434 (33.5%) missing values | Missing |
session_left has 93690 (77.6%) missing values | Missing |
case_type has 35575 (29.5%) missing values | Missing |
cancelled_at has 73418 (60.8%) missing values | Missing |
billable_item has 18250 (15.1%) missing values | Missing |
category has 24615 (20.4%) missing values | Missing |
concession_type has 97703 (81.0%) missing values | Missing |
customer_type has 77964 (64.6%) missing values | Missing |
title has 53560 (44.4%) missing values | Missing |
state has 58312 (48.3%) missing values | Missing |
sex has 53523 (44.3%) missing values | Missing |
post_code has 56784 (47.0%) missing values | Missing |
city has 56373 (46.7%) missing values | Missing |
occupation has 50304 (41.7%) missing values | Missing |
total_closed_invoices_before_appointemnt has 80258 (66.5%) missing values | Missing |
total_open_invoices_before_appointemnt is highly skewed (γ1 = 24.28150002) | Skewed |
post_code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
total_open_invoices_before_appointemnt has 79567 (65.9%) zeros | Zeros |
total_good_appointments_before_cancelled_appointment has 77555 (64.3%) zeros | Zeros |
total_cxl_appointments_before_cancelled_appointment has 89930 (74.5%) zeros | Zeros |
percentage_good_appointments_and_missed_appointments_before_can has 89930 (74.5%) zeros | Zeros |
notice has 73418 (60.8%) zeros | Zeros |
session_left has 13663 (11.3%) zeros | Zeros |
total_closed_invoices_before_appointemnt has 10447 (8.7%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-30 06:09:29.633640 |
|---|---|
| Analysis finished | 2024-05-30 06:10:49.190157 |
| Duration | 1 minute and 19.56 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
opened_case_name
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35575 |
| Missing (%) | 29.5% |
| Memory size | 1.8 MiB |
| Opened | |
|---|---|
| Expired | |
| Closed |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 6.2799676 |
| Min length | 6 |
Characters and Unicode
| Total characters | 534532 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Expired |
|---|---|
| 2nd row | Expired |
| 3rd row | Opened |
| 4th row | Expired |
| 5th row | Opened |
Common Values
| Value | Count | Frequency (%) |
| Opened | 47331 | |
| Expired | 23830 | |
| Closed | 13956 | 11.6% |
| (Missing) | 35575 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| opened | 47331 | |
| expired | 23830 | |
| closed | 13956 | 16.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 132448 | |
| d | 85117 | |
| p | 71161 | |
| O | 47331 | 8.9% |
| n | 47331 | 8.9% |
| E | 23830 | 4.5% |
| x | 23830 | 4.5% |
| i | 23830 | 4.5% |
| r | 23830 | 4.5% |
| C | 13956 | 2.6% |
| Other values (3) | 41868 | 7.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 534532 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 132448 | |
| d | 85117 | |
| p | 71161 | |
| O | 47331 | 8.9% |
| n | 47331 | 8.9% |
| E | 23830 | 4.5% |
| x | 23830 | 4.5% |
| i | 23830 | 4.5% |
| r | 23830 | 4.5% |
| C | 13956 | 2.6% |
| Other values (3) | 41868 | 7.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 534532 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 132448 | |
| d | 85117 | |
| p | 71161 | |
| O | 47331 | 8.9% |
| n | 47331 | 8.9% |
| E | 23830 | 4.5% |
| x | 23830 | 4.5% |
| i | 23830 | 4.5% |
| r | 23830 | 4.5% |
| C | 13956 | 2.6% |
| Other values (3) | 41868 | 7.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 534532 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 132448 | |
| d | 85117 | |
| p | 71161 | |
| O | 47331 | 8.9% |
| n | 47331 | 8.9% |
| E | 23830 | 4.5% |
| x | 23830 | 4.5% |
| i | 23830 | 4.5% |
| r | 23830 | 4.5% |
| C | 13956 | 2.6% |
| Other values (3) | 41868 | 7.8% |
total_open_invoices_before_appointemnt
Real number (ℝ)
MISSING  SKEWED  ZEROS 
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 40434 |
| Missing (%) | 33.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.014602906 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 79567 |
| Zeros (%) | 65.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.20482016 |
|---|---|
| Coefficient of variation (CV) | 14.025987 |
| Kurtosis | 830.5179 |
| Mean | 0.014602906 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.2815 |
| Sum | 1172 |
| Variance | 0.041951299 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 79567 | |
| 1 | 464 | 0.4% |
| 2 | 120 | 0.1% |
| 3 | 46 | < 0.1% |
| 4 | 33 | < 0.1% |
| 5 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 3 | < 0.1% |
| (Missing) | 40434 |
| Value | Count | Frequency (%) |
| 0 | 79567 | |
| 1 | 464 | 0.4% |
| 2 | 120 | 0.1% |
| 3 | 46 | < 0.1% |
| 4 | 33 | < 0.1% |
| 5 | 7 | < 0.1% |
| 6 | 6 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 11 | 3 | < 0.1% |
| 9 | 3 | < 0.1% |
| 8 | 4 | < 0.1% |
| 7 | 5 | < 0.1% |
| 6 | 6 | < 0.1% |
| 5 | 7 | < 0.1% |
| 4 | 33 | < 0.1% |
| 3 | 46 | < 0.1% |
| 2 | 120 | 0.1% |
| 1 | 464 |
total_good_appointments_before_cancelled_appointment
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 169 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2793083 |
| Minimum | 0 |
|---|---|
| Maximum | 295 |
| Zeros | 77555 |
| Zeros (%) | 64.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 26 |
| Maximum | 295 |
| Range | 295 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 16.78981 |
|---|---|
| Coefficient of variation (CV) | 3.1803048 |
| Kurtosis | 74.334661 |
| Mean | 5.2793083 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.2611588 |
| Sum | 637165 |
| Variance | 281.89771 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 77555 | |
| 2 | 4898 | 4.1% |
| 1 | 4656 | 3.9% |
| 3 | 4097 | 3.4% |
| 4 | 3435 | 2.8% |
| 5 | 2901 | 2.4% |
| 6 | 2272 | 1.9% |
| 7 | 1725 | 1.4% |
| 8 | 1587 | 1.3% |
| 9 | 1399 | 1.2% |
| Other values (159) | 16166 | 13.4% |
| Value | Count | Frequency (%) |
| 0 | 77555 | |
| 1 | 4656 | 3.9% |
| 2 | 4898 | 4.1% |
| 3 | 4097 | 3.4% |
| 4 | 3435 | 2.8% |
| 5 | 2901 | 2.4% |
| 6 | 2272 | 1.9% |
| 7 | 1725 | 1.4% |
| 8 | 1587 | 1.3% |
| 9 | 1399 | 1.2% |
| Value | Count | Frequency (%) |
| 295 | 4 | |
| 294 | 4 | |
| 288 | 4 | |
| 286 | 8 | |
| 278 | 4 | |
| 271 | 4 | |
| 270 | 4 | |
| 267 | 4 | |
| 264 | 8 | |
| 261 | 4 |
total_cxl_appointments_before_cancelled_appointment
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 110 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1101481 |
| Minimum | 0 |
|---|---|
| Maximum | 144 |
| Zeros | 89930 |
| Zeros (%) | 74.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 11 |
| Maximum | 144 |
| Range | 144 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 7.8406378 |
|---|---|
| Coefficient of variation (CV) | 3.7156812 |
| Kurtosis | 75.060122 |
| Mean | 2.1101481 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.4665406 |
| Sum | 254678 |
| Variance | 61.4756 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 89930 | |
| 1 | 7858 | 6.5% |
| 2 | 4584 | 3.8% |
| 3 | 3048 | 2.5% |
| 4 | 2287 | 1.9% |
| 5 | 1822 | 1.5% |
| 6 | 1490 | 1.2% |
| 7 | 1009 | 0.8% |
| 10 | 920 | 0.8% |
| 8 | 872 | 0.7% |
| Other values (100) | 6872 | 5.7% |
| Value | Count | Frequency (%) |
| 0 | 89930 | |
| 1 | 7858 | 6.5% |
| 2 | 4584 | 3.8% |
| 3 | 3048 | 2.5% |
| 4 | 2287 | 1.9% |
| 5 | 1822 | 1.5% |
| 6 | 1490 | 1.2% |
| 7 | 1009 | 0.8% |
| 8 | 872 | 0.7% |
| 9 | 763 | 0.6% |
| Value | Count | Frequency (%) |
| 144 | 4 | < 0.1% |
| 143 | 4 | < 0.1% |
| 137 | 4 | < 0.1% |
| 136 | 4 | < 0.1% |
| 134 | 4 | < 0.1% |
| 131 | 4 | < 0.1% |
| 126 | 8 | |
| 123 | 12 | |
| 118 | 4 | < 0.1% |
| 116 | 4 | < 0.1% |
percentage_good_appointments_and_missed_appointments_before_can
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 843 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.2074556 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 89930 |
| Zeros (%) | 74.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4.8387097 |
| 95-th percentile | 57.142857 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 4.8387097 |
Descriptive statistics
| Standard deviation | 20.531745 |
|---|---|
| Coefficient of variation (CV) | 2.2299043 |
| Kurtosis | 6.8826289 |
| Mean | 9.2074556 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.659494 |
| Sum | 1111266.2 |
| Variance | 421.55254 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 89930 | |
| 33.33333333 | 1749 | 1.4% |
| 50 | 1726 | 1.4% |
| 100 | 1604 | 1.3% |
| 25 | 1579 | 1.3% |
| 20 | 1228 | 1.0% |
| 16.66666667 | 911 | 0.8% |
| 14.28571429 | 790 | 0.7% |
| 11.11111111 | 649 | 0.5% |
| 12.5 | 616 | 0.5% |
| Other values (833) | 19910 | 16.5% |
| Value | Count | Frequency (%) |
| 0 | 89930 | |
| 1.612903226 | 12 | < 0.1% |
| 1.724137931 | 20 | < 0.1% |
| 1.754385965 | 2 | < 0.1% |
| 1.960784314 | 2 | < 0.1% |
| 2.083333333 | 2 | < 0.1% |
| 2.127659574 | 4 | < 0.1% |
| 2.173913043 | 1 | < 0.1% |
| 2.380952381 | 7 | < 0.1% |
| 2.43902439 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 100 | 1604 | |
| 95.45454545 | 21 | < 0.1% |
| 95.23809524 | 20 | < 0.1% |
| 93.33333333 | 28 | < 0.1% |
| 92.30769231 | 48 | < 0.1% |
| 91.89189189 | 34 | < 0.1% |
| 91.66666667 | 33 | < 0.1% |
| 91.52542373 | 54 | < 0.1% |
| 91.30434783 | 21 | < 0.1% |
| 90.90909091 | 51 | < 0.1% |
patient_status
Categorical
IMBALANCE 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Not Yet Actioned | |
|---|---|
| Therapist Follow Up | 3223 |
| Has An Upcoming Booking | 1504 |
| Patient Stopped Treatment | 892 |
| Admin Follow Up | 400 |
| Other values (5) | 335 |
Length
| Max length | 25 |
|---|---|
| Median length | 16 |
| Mean length | 16.237033 |
| Min length | 14 |
Characters and Unicode
| Total characters | 1959680 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Yet Actioned |
|---|---|
| 2nd row | Not Yet Actioned |
| 3rd row | Not Yet Actioned |
| 4th row | Not Yet Actioned |
| 5th row | Admin Follow Up |
Common Values
| Value | Count | Frequency (%) |
| Not Yet Actioned | 114338 | |
| Therapist Follow Up | 3223 | 2.7% |
| Has An Upcoming Booking | 1504 | 1.2% |
| Patient Stopped Treatment | 892 | 0.7% |
| Admin Follow Up | 400 | 0.3% |
| On Waiting List | 114 | 0.1% |
| Discharged By Therapist | 111 | 0.1% |
| Do Not Contact | 44 | < 0.1% |
| Contacted Too Many Times | 34 | < 0.1% |
| Staff & Family | 32 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| not | 114382 | |
| actioned | 114338 | |
| yet | 114338 | |
| follow | 3623 | 1.0% |
| up | 3623 | 1.0% |
| therapist | 3334 | 0.9% |
| has | 1504 | 0.4% |
| an | 1504 | 0.4% |
| upcoming | 1504 | 0.4% |
| booking | 1504 | 0.4% |
| Other values (18) | 3960 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 351268 | |
| 242922 | ||
| o | 241560 | |
| e | 235757 | |
| i | 122491 | 6.3% |
| n | 121374 | 6.2% |
| A | 116242 | 5.9% |
| c | 116031 | 5.9% |
| d | 115775 | 5.9% |
| N | 114382 | 5.8% |
| Other values (27) | 181878 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1959680 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 351268 | |
| 242922 | ||
| o | 241560 | |
| e | 235757 | |
| i | 122491 | 6.3% |
| n | 121374 | 6.2% |
| A | 116242 | 5.9% |
| c | 116031 | 5.9% |
| d | 115775 | 5.9% |
| N | 114382 | 5.8% |
| Other values (27) | 181878 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1959680 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 351268 | |
| 242922 | ||
| o | 241560 | |
| e | 235757 | |
| i | 122491 | 6.3% |
| n | 121374 | 6.2% |
| A | 116242 | 5.9% |
| c | 116031 | 5.9% |
| d | 115775 | 5.9% |
| N | 114382 | 5.8% |
| Other values (27) | 181878 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1959680 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 351268 | |
| 242922 | ||
| o | 241560 | |
| e | 235757 | |
| i | 122491 | 6.3% |
| n | 121374 | 6.2% |
| A | 116242 | 5.9% |
| c | 116031 | 5.9% |
| d | 115775 | 5.9% |
| N | 114382 | 5.8% |
| Other values (27) | 181878 |
patient_type
Categorical
HIGH CORRELATION 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| New To Clinic | |
|---|---|
| Recurring | |
| new to therapist | 2304 |
| new injury/issue | 1967 |
| new to service | 485 |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 11.838548 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1428818 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Recurring |
|---|---|
| 2nd row | New To Clinic |
| 3rd row | Recurring |
| 4th row | Recurring |
| 5th row | Recurring |
Common Values
| Value | Count | Frequency (%) |
| New To Clinic | 77567 | |
| Recurring | 38369 | |
| new to therapist | 2304 | 1.9% |
| new injury/issue | 1967 | 1.6% |
| new to service | 485 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| new | 82323 | |
| to | 80356 | |
| clinic | 77567 | |
| recurring | 38369 | |
| therapist | 2304 | 0.8% |
| injury/issue | 1967 | 0.7% |
| service | 485 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 200226 | |
| 162679 | ||
| e | 125933 | |
| n | 122659 | |
| c | 116421 | 8.1% |
| w | 82323 | 5.8% |
| r | 81494 | 5.7% |
| o | 80356 | 5.6% |
| N | 77567 | 5.4% |
| T | 77567 | 5.4% |
| Other values (14) | 301593 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1428818 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 200226 | |
| 162679 | ||
| e | 125933 | |
| n | 122659 | |
| c | 116421 | 8.1% |
| w | 82323 | 5.8% |
| r | 81494 | 5.7% |
| o | 80356 | 5.6% |
| N | 77567 | 5.4% |
| T | 77567 | 5.4% |
| Other values (14) | 301593 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1428818 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 200226 | |
| 162679 | ||
| e | 125933 | |
| n | 122659 | |
| c | 116421 | 8.1% |
| w | 82323 | 5.8% |
| r | 81494 | 5.7% |
| o | 80356 | 5.6% |
| N | 77567 | 5.4% |
| T | 77567 | 5.4% |
| Other values (14) | 301593 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1428818 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 200226 | |
| 162679 | ||
| e | 125933 | |
| n | 122659 | |
| c | 116421 | 8.1% |
| w | 82323 | 5.8% |
| r | 81494 | 5.7% |
| o | 80356 | 5.6% |
| N | 77567 | 5.4% |
| T | 77567 | 5.4% |
| Other values (14) | 301593 |
time_of_day
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Afternoon | |
|---|---|
| Morning | |
| Evening |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.9583237 |
| Min length | 7 |
Characters and Unicode
| Total characters | 960506 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morning |
|---|---|
| 2nd row | Morning |
| 3rd row | Afternoon |
| 4th row | Afternoon |
| 5th row | Morning |
Common Values
| Value | Count | Frequency (%) |
| Afternoon | 57831 | |
| Morning | 55857 | |
| Evening | 7004 | 5.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| afternoon | 57831 | |
| morning | 55857 | |
| evening | 7004 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 241384 | |
| o | 171519 | |
| r | 113688 | |
| e | 64835 | 6.8% |
| i | 62861 | 6.5% |
| g | 62861 | 6.5% |
| A | 57831 | 6.0% |
| f | 57831 | 6.0% |
| t | 57831 | 6.0% |
| M | 55857 | 5.8% |
| Other values (2) | 14008 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 960506 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 241384 | |
| o | 171519 | |
| r | 113688 | |
| e | 64835 | 6.8% |
| i | 62861 | 6.5% |
| g | 62861 | 6.5% |
| A | 57831 | 6.0% |
| f | 57831 | 6.0% |
| t | 57831 | 6.0% |
| M | 55857 | 5.8% |
| Other values (2) | 14008 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 960506 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 241384 | |
| o | 171519 | |
| r | 113688 | |
| e | 64835 | 6.8% |
| i | 62861 | 6.5% |
| g | 62861 | 6.5% |
| A | 57831 | 6.0% |
| f | 57831 | 6.0% |
| t | 57831 | 6.0% |
| M | 55857 | 5.8% |
| Other values (2) | 14008 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 960506 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 241384 | |
| o | 171519 | |
| r | 113688 | |
| e | 64835 | 6.8% |
| i | 62861 | 6.5% |
| g | 62861 | 6.5% |
| A | 57831 | 6.0% |
| f | 57831 | 6.0% |
| t | 57831 | 6.0% |
| M | 55857 | 5.8% |
| Other values (2) | 14008 | 1.5% |
day_of_week
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 1.8 MiB |
| Thursday | |
|---|---|
| Tuesday | |
| Wednesday | |
| Monday | |
| Friday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1086210 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tuesday |
|---|---|
| 2nd row | Thursday |
| 3rd row | Friday |
| 4th row | Friday |
| 5th row | Monday |
Common Values
| Value | Count | Frequency (%) |
| Thursday | 25279 | |
| Tuesday | 24118 | |
| Wednesday | 23033 | |
| Monday | 20414 | |
| Friday | 20266 | |
| Saturday | 7514 | 6.2% |
| Sunday | 66 | 0.1% |
| (Missing) | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| thursday | 25279 | |
| tuesday | 24118 | |
| wednesday | 23033 | |
| monday | 20414 | |
| friday | 20266 | |
| saturday | 7514 | 6.2% |
| sunday | 66 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 203267 | ||
| d | 143723 | |
| a | 128204 | |
| y | 120690 | |
| s | 72430 | 6.7% |
| e | 70184 | 6.5% |
| u | 56977 | 5.2% |
| r | 53059 | 4.9% |
| T | 49397 | 4.5% |
| n | 43513 | 4.0% |
| Other values (8) | 144766 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 203267 | ||
| d | 143723 | |
| a | 128204 | |
| y | 120690 | |
| s | 72430 | 6.7% |
| e | 70184 | 6.5% |
| u | 56977 | 5.2% |
| r | 53059 | 4.9% |
| T | 49397 | 4.5% |
| n | 43513 | 4.0% |
| Other values (8) | 144766 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 203267 | ||
| d | 143723 | |
| a | 128204 | |
| y | 120690 | |
| s | 72430 | 6.7% |
| e | 70184 | 6.5% |
| u | 56977 | 5.2% |
| r | 53059 | 4.9% |
| T | 49397 | 4.5% |
| n | 43513 | 4.0% |
| Other values (8) | 144766 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 203267 | ||
| d | 143723 | |
| a | 128204 | |
| y | 120690 | |
| s | 72430 | 6.7% |
| e | 70184 | 6.5% |
| u | 56977 | 5.2% |
| r | 53059 | 4.9% |
| T | 49397 | 4.5% |
| n | 43513 | 4.0% |
| Other values (8) | 144766 |
month_of_year
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 1.8 MiB |
| May | |
|---|---|
| March | |
| November | |
| April | |
| February | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1086210 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | November |
|---|---|
| 2nd row | October |
| 3rd row | October |
| 4th row | October |
| 5th row | March |
Common Values
| Value | Count | Frequency (%) |
| May | 12686 | |
| March | 11880 | |
| November | 11608 | |
| April | 11227 | |
| February | 11119 | |
| January | 10627 | |
| December | 9992 | |
| June | 9277 | |
| August | 8500 | |
| October | 8455 | |
| Other values (2) | 15319 |
Length
| Value | Count | Frequency (%) |
| may | 12686 | |
| march | 11880 | |
| november | 11608 | |
| april | 11227 | |
| february | 11119 | |
| january | 10627 | |
| december | 9992 | |
| june | 9277 | |
| august | 8500 | |
| october | 8455 | |
| Other values (2) | 15319 |
Most occurring characters
| Value | Count | Frequency (%) |
| 350992 | ||
| e | 104192 | 9.6% |
| r | 93410 | 8.6% |
| a | 56939 | 5.2% |
| u | 55959 | 5.2% |
| b | 48557 | 4.5% |
| y | 42368 | 3.9% |
| c | 30327 | 2.8% |
| m | 28983 | 2.7% |
| J | 27840 | 2.6% |
| Other values (17) | 246643 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 350992 | ||
| e | 104192 | 9.6% |
| r | 93410 | 8.6% |
| a | 56939 | 5.2% |
| u | 55959 | 5.2% |
| b | 48557 | 4.5% |
| y | 42368 | 3.9% |
| c | 30327 | 2.8% |
| m | 28983 | 2.7% |
| J | 27840 | 2.6% |
| Other values (17) | 246643 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 350992 | ||
| e | 104192 | 9.6% |
| r | 93410 | 8.6% |
| a | 56939 | 5.2% |
| u | 55959 | 5.2% |
| b | 48557 | 4.5% |
| y | 42368 | 3.9% |
| c | 30327 | 2.8% |
| m | 28983 | 2.7% |
| J | 27840 | 2.6% |
| Other values (17) | 246643 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1086210 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 350992 | ||
| e | 104192 | 9.6% |
| r | 93410 | 8.6% |
| a | 56939 | 5.2% |
| u | 55959 | 5.2% |
| b | 48557 | 4.5% |
| y | 42368 | 3.9% |
| c | 30327 | 2.8% |
| m | 28983 | 2.7% |
| J | 27840 | 2.6% |
| Other values (17) | 246643 |
week_of_year
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.408427 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 12 |
| median | 23 |
| Q3 | 39 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.283636 |
|---|---|
| Coefficient of variation (CV) | 0.60151839 |
| Kurtosis | -1.250821 |
| Mean | 25.408427 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 0.15891625 |
| Sum | 3066543 |
| Variance | 233.58953 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 2929 | 2.4% |
| 21 | 2925 | 2.4% |
| 45 | 2902 | 2.4% |
| 51 | 2880 | 2.4% |
| 9 | 2826 | 2.3% |
| 12 | 2823 | 2.3% |
| 50 | 2815 | 2.3% |
| 19 | 2806 | 2.3% |
| 46 | 2802 | 2.3% |
| 2 | 2797 | 2.3% |
| Other values (43) | 92185 |
| Value | Count | Frequency (%) |
| 1 | 1778 | |
| 2 | 2797 | |
| 3 | 2596 | |
| 4 | 2292 | |
| 5 | 2749 | |
| 6 | 2711 | |
| 7 | 2517 | |
| 8 | 2763 | |
| 9 | 2826 | |
| 10 | 2743 |
| Value | Count | Frequency (%) |
| 53 | 82 | 0.1% |
| 52 | 868 | 0.7% |
| 51 | 2880 | |
| 50 | 2815 | |
| 49 | 2649 | |
| 48 | 2715 | |
| 47 | 2652 | |
| 46 | 2802 | |
| 45 | 2902 | |
| 44 | 2079 |
appointment_status
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Not Rebooked | |
|---|---|
| Rebooked |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 10.95317 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1321960 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Rebooked |
|---|---|
| 2nd row | Not Rebooked |
| 3rd row | Rebooked |
| 4th row | Rebooked |
| 5th row | Not Rebooked |
Common Values
| Value | Count | Frequency (%) |
| Not Rebooked | 89106 | |
| Rebooked | 31586 | 26.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rebooked | 120692 | |
| not | 89106 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 330490 | |
| e | 241384 | |
| R | 120692 | 9.1% |
| b | 120692 | 9.1% |
| k | 120692 | 9.1% |
| d | 120692 | 9.1% |
| N | 89106 | 6.7% |
| t | 89106 | 6.7% |
| 89106 | 6.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1321960 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 330490 | |
| e | 241384 | |
| R | 120692 | 9.1% |
| b | 120692 | 9.1% |
| k | 120692 | 9.1% |
| d | 120692 | 9.1% |
| N | 89106 | 6.7% |
| t | 89106 | 6.7% |
| 89106 | 6.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1321960 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 330490 | |
| e | 241384 | |
| R | 120692 | 9.1% |
| b | 120692 | 9.1% |
| k | 120692 | 9.1% |
| d | 120692 | 9.1% |
| N | 89106 | 6.7% |
| t | 89106 | 6.7% |
| 89106 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1321960 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 330490 | |
| e | 241384 | |
| R | 120692 | 9.1% |
| b | 120692 | 9.1% |
| k | 120692 | 9.1% |
| d | 120692 | 9.1% |
| N | 89106 | 6.7% |
| t | 89106 | 6.7% |
| 89106 | 6.7% |
notice
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 21560 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -942.49932 |
| Minimum | -65869.135 |
|---|---|
| Maximum | 17186.203 |
| Zeros | 73418 |
| Zeros (%) | 60.8% |
| Negative | 8585 |
| Negative (%) | 7.1% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | -65869.135 |
|---|---|
| 5-th percentile | -5869.3219 |
| Q1 | 0 |
| median | 0 |
| Q3 | 9.1475694 |
| 95-th percentile | 188.73361 |
| Maximum | 17186.203 |
| Range | 83055.338 |
| Interquartile range (IQR) | 9.1475694 |
Descriptive statistics
| Standard deviation | 5118.1669 |
|---|---|
| Coefficient of variation (CV) | -5.4304197 |
| Kurtosis | 52.202731 |
| Mean | -942.49932 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -6.3933856 |
| Sum | -1.1375213 × 108 |
| Variance | 26195633 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 73418 | |
| 25.56361111 | 16 | < 0.1% |
| 39.83416667 | 14 | < 0.1% |
| 1.076111111 | 14 | < 0.1% |
| 22.41583333 | 14 | < 0.1% |
| 42.14527778 | 14 | < 0.1% |
| 43.61527778 | 14 | < 0.1% |
| 22.88638889 | 14 | < 0.1% |
| 20.045 | 14 | < 0.1% |
| 1.436666667 | 14 | < 0.1% |
| Other values (21550) | 47146 |
| Value | Count | Frequency (%) |
| -65869.135 | 1 | |
| -65863.135 | 1 | |
| -65692.135 | 1 | |
| -65578.635 | 1 | |
| -65482.635 | 1 | |
| -65476.135 | 1 | |
| -65142.635 | 1 | |
| -65020.635 | 1 | |
| -64684.135 | 1 | |
| -63829.135 | 1 |
| Value | Count | Frequency (%) |
| 17186.20278 | 4 | |
| 16850.20278 | 4 | |
| 16514.20278 | 4 | |
| 16178.20278 | 4 | |
| 15842.20278 | 4 | |
| 15506.20278 | 4 | |
| 15170.20278 | 4 | |
| 14834.20306 | 4 | |
| 14498.20306 | 4 | |
| 14162.20306 | 4 |
session_left
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 93690 |
| Missing (%) | 77.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5521443 |
| Minimum | 0 |
|---|---|
| Maximum | 28 |
| Zeros | 13663 |
| Zeros (%) | 11.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.3283571 |
|---|---|
| Coefficient of variation (CV) | 1.5000906 |
| Kurtosis | 10.286529 |
| Mean | 1.5521443 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.409773 |
| Sum | 41911 |
| Variance | 5.4212467 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 13663 | 11.3% |
| 1 | 3831 | 3.2% |
| 2 | 2692 | 2.2% |
| 3 | 2576 | 2.1% |
| 4 | 1746 | 1.4% |
| 5 | 790 | 0.7% |
| 6 | 419 | 0.3% |
| 7 | 384 | 0.3% |
| 8 | 254 | 0.2% |
| 11 | 232 | 0.2% |
| Other values (7) | 415 | 0.3% |
| (Missing) | 93690 |
| Value | Count | Frequency (%) |
| 0 | 13663 | |
| 1 | 3831 | 3.2% |
| 2 | 2692 | 2.2% |
| 3 | 2576 | 2.1% |
| 4 | 1746 | 1.4% |
| 5 | 790 | 0.7% |
| 6 | 419 | 0.3% |
| 7 | 384 | 0.3% |
| 8 | 254 | 0.2% |
| 9 | 224 | 0.2% |
| Value | Count | Frequency (%) |
| 28 | 10 | < 0.1% |
| 23 | 2 | < 0.1% |
| 16 | 8 | < 0.1% |
| 13 | 16 | < 0.1% |
| 12 | 10 | < 0.1% |
| 11 | 232 | |
| 10 | 145 | 0.1% |
| 9 | 224 | |
| 8 | 254 | |
| 7 | 384 |
case_type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 35575 |
| Missing (%) | 29.5% |
| Memory size | 1.8 MiB |
| Unlimited | |
|---|---|
| Max Sessions | |
| Max Amount | 204 |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 10.053632 |
| Min length | 9 |
Characters and Unicode
| Total characters | 855735 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Unlimited |
|---|---|
| 2nd row | Unlimited |
| 3rd row | Unlimited |
| 4th row | Unlimited |
| 5th row | Unlimited |
Common Values
| Value | Count | Frequency (%) |
| Unlimited | 55087 | |
| Max Sessions | 29826 | |
| Max Amount | 204 | 0.2% |
| (Missing) | 35575 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unlimited | 55087 | |
| max | 30030 | |
| sessions | 29826 | |
| amount | 204 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 140000 | |
| s | 89478 | |
| n | 85117 | |
| e | 84913 | |
| m | 55291 | 6.5% |
| t | 55291 | 6.5% |
| U | 55087 | 6.4% |
| l | 55087 | 6.4% |
| d | 55087 | 6.4% |
| 30030 | 3.5% | |
| Other values (7) | 150354 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 855735 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 140000 | |
| s | 89478 | |
| n | 85117 | |
| e | 84913 | |
| m | 55291 | 6.5% |
| t | 55291 | 6.5% |
| U | 55087 | 6.4% |
| l | 55087 | 6.4% |
| d | 55087 | 6.4% |
| 30030 | 3.5% | |
| Other values (7) | 150354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 855735 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 140000 | |
| s | 89478 | |
| n | 85117 | |
| e | 84913 | |
| m | 55291 | 6.5% |
| t | 55291 | 6.5% |
| U | 55087 | 6.4% |
| l | 55087 | 6.4% |
| d | 55087 | 6.4% |
| 30030 | 3.5% | |
| Other values (7) | 150354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 855735 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 140000 | |
| s | 89478 | |
| n | 85117 | |
| e | 84913 | |
| m | 55291 | 6.5% |
| t | 55291 | 6.5% |
| U | 55087 | 6.4% |
| l | 55087 | 6.4% |
| d | 55087 | 6.4% |
| 30030 | 3.5% | |
| Other values (7) | 150354 |
cancelled_at
Date
MISSING 
| Distinct | 14962 |
|---|---|
| Distinct (%) | 31.6% |
| Missing | 73418 |
| Missing (%) | 60.8% |
| Memory size | 1.8 MiB |
| Minimum | 2020-07-16 08:36:13+00:00 |
|---|---|
| Maximum | 2024-05-28 08:47:23+00:00 |
appointment_type
Text
| Distinct | 444 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 61 |
| Missing (%) | 0.1% |
| Memory size | 1.8 MiB |
Length
| Max length | 106 |
|---|---|
| Median length | 87 |
| Mean length | 47.577563 |
| Min length | 4 |
Characters and Unicode
| Total characters | 5739329 |
|---|---|
| Distinct characters | 86 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2. Physiotherapy - 30 Minute Follow Up Consult |
|---|---|
| 2nd row | 1. ⭐️ Physiotherapy - 45 Minute Initial Consult |
| 3rd row | 2. Physiotherapy - 30 Minute Follow Up Consult |
| 4th row | 2. Physiotherapy - 30 Minute Follow Up Consult |
| 5th row | 2. Physiotherapy - 30 Minute Follow Up Consult |
| Value | Count | Frequency (%) |
| 112374 | 13.0% | |
| consult | 51921 | 6.0% |
| subsequent | 46188 | 5.3% |
| 2 | 45668 | 5.3% |
| consultation | 45595 | 5.3% |
| up | 44162 | 5.1% |
| follow | 44126 | 5.1% |
| minute | 32630 | 3.8% |
| physiotherapy | 29759 | 3.4% |
| osteopathy | 23229 | 2.7% |
| Other values (331) | 390279 |
Most occurring characters
| Value | Count | Frequency (%) |
| 747808 | 13.0% | |
| t | 459919 | 8.0% |
| o | 409890 | 7.1% |
| n | 357066 | 6.2% |
| e | 351873 | 6.1% |
| s | 314104 | 5.5% |
| i | 296746 | 5.2% |
| l | 249052 | 4.3% |
| u | 242829 | 4.2% |
| a | 201012 | 3.5% |
| Other values (76) | 2109030 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5739329 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 747808 | 13.0% | |
| t | 459919 | 8.0% |
| o | 409890 | 7.1% |
| n | 357066 | 6.2% |
| e | 351873 | 6.1% |
| s | 314104 | 5.5% |
| i | 296746 | 5.2% |
| l | 249052 | 4.3% |
| u | 242829 | 4.2% |
| a | 201012 | 3.5% |
| Other values (76) | 2109030 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5739329 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 747808 | 13.0% | |
| t | 459919 | 8.0% |
| o | 409890 | 7.1% |
| n | 357066 | 6.2% |
| e | 351873 | 6.1% |
| s | 314104 | 5.5% |
| i | 296746 | 5.2% |
| l | 249052 | 4.3% |
| u | 242829 | 4.2% |
| a | 201012 | 3.5% |
| Other values (76) | 2109030 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5739329 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 747808 | 13.0% | |
| t | 459919 | 8.0% |
| o | 409890 | 7.1% |
| n | 357066 | 6.2% |
| e | 351873 | 6.1% |
| s | 314104 | 5.5% |
| i | 296746 | 5.2% |
| l | 249052 | 4.3% |
| u | 242829 | 4.2% |
| a | 201012 | 3.5% |
| Other values (76) | 2109030 |
billable_item
Text
MISSING 
| Distinct | 348 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 18250 |
| Missing (%) | 15.1% |
| Memory size | 1.8 MiB |
Length
| Max length | 115 |
|---|---|
| Median length | 89 |
| Mean length | 46.591915 |
| Min length | 11 |
Characters and Unicode
| Total characters | 4772969 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Physiotherapy - 30 Minute Follow Up Consult |
|---|---|
| 2nd row | Physiotherapy - 45 Minute Initial Consult |
| 3rd row | Physiotherapy - 30 Minute Follow Up Consult |
| 4th row | Physiotherapy - 30 Minute Follow Up Consult |
| 5th row | Physiotherapy - 30 Minute Follow Up Consult |
| Value | Count | Frequency (%) |
| 96129 | ||
| consult | 51612 | 7.7% |
| subsequent | 46927 | 7.0% |
| consultation | 45101 | 6.8% |
| up | 42973 | 6.4% |
| follow | 42910 | 6.4% |
| osteopathy | 36693 | 5.5% |
| minute | 32137 | 4.8% |
| physiotherapy | 29100 | 4.4% |
| 30 | 22594 | 3.4% |
| Other values (249) | 220086 |
Most occurring characters
| Value | Count | Frequency (%) |
| 579642 | 12.1% | |
| t | 392528 | 8.2% |
| o | 373034 | 7.8% |
| n | 306944 | 6.4% |
| e | 295966 | 6.2% |
| s | 282801 | 5.9% |
| i | 260542 | 5.5% |
| l | 246385 | 5.2% |
| u | 243169 | 5.1% |
| a | 197942 | 4.1% |
| Other values (60) | 1594016 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4772969 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 579642 | 12.1% | |
| t | 392528 | 8.2% |
| o | 373034 | 7.8% |
| n | 306944 | 6.4% |
| e | 295966 | 6.2% |
| s | 282801 | 5.9% |
| i | 260542 | 5.5% |
| l | 246385 | 5.2% |
| u | 243169 | 5.1% |
| a | 197942 | 4.1% |
| Other values (60) | 1594016 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4772969 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 579642 | 12.1% | |
| t | 392528 | 8.2% |
| o | 373034 | 7.8% |
| n | 306944 | 6.4% |
| e | 295966 | 6.2% |
| s | 282801 | 5.9% |
| i | 260542 | 5.5% |
| l | 246385 | 5.2% |
| u | 243169 | 5.1% |
| a | 197942 | 4.1% |
| Other values (60) | 1594016 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4772969 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 579642 | 12.1% | |
| t | 392528 | 8.2% |
| o | 373034 | 7.8% |
| n | 306944 | 6.4% |
| e | 295966 | 6.2% |
| s | 282801 | 5.9% |
| i | 260542 | 5.5% |
| l | 246385 | 5.2% |
| u | 243169 | 5.1% |
| a | 197942 | 4.1% |
| Other values (60) | 1594016 |
category
Text
MISSING 
| Distinct | 139 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 24615 |
| Missing (%) | 20.4% |
| Memory size | 1.8 MiB |
Length
| Max length | 68 |
|---|---|
| Median length | 60 |
| Mean length | 33.025146 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3172957 |
|---|---|
| Distinct characters | 90 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A | PHYSIOTHERAPY |
|---|---|
| 2nd row | A | PHYSIOTHERAPY |
| 3rd row | A | PHYSIOTHERAPY |
| 4th row | A | PHYSIOTHERAPY |
| 5th row | A | PHYSIOTHERAPY |
| Value | Count | Frequency (%) |
| 55387 | 11.6% | |
| 2 | 36191 | 7.5% |
| subsequent | 30047 | 6.3% |
| consultations | 29138 | 6.1% |
| for | 28877 | 6.0% |
| osteopathy | 28582 | 6.0% |
| existing | 28464 | 5.9% |
| patients | 28464 | 5.9% |
| physiotherapy | 18041 | 3.8% |
| a | 17257 | 3.6% |
| Other values (191) | 178957 |
Most occurring characters
| Value | Count | Frequency (%) |
| 385066 | 12.1% | |
| t | 251135 | 7.9% |
| s | 219566 | 6.9% |
| e | 176794 | 5.6% |
| n | 160850 | 5.1% |
| o | 145076 | 4.6% |
| i | 139802 | 4.4% |
| a | 135318 | 4.3% |
| P | 103035 | 3.2% |
| u | 98842 | 3.1% |
| Other values (80) | 1357473 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3172957 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 385066 | 12.1% | |
| t | 251135 | 7.9% |
| s | 219566 | 6.9% |
| e | 176794 | 5.6% |
| n | 160850 | 5.1% |
| o | 145076 | 4.6% |
| i | 139802 | 4.4% |
| a | 135318 | 4.3% |
| P | 103035 | 3.2% |
| u | 98842 | 3.1% |
| Other values (80) | 1357473 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3172957 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 385066 | 12.1% | |
| t | 251135 | 7.9% |
| s | 219566 | 6.9% |
| e | 176794 | 5.6% |
| n | 160850 | 5.1% |
| o | 145076 | 4.6% |
| i | 139802 | 4.4% |
| a | 135318 | 4.3% |
| P | 103035 | 3.2% |
| u | 98842 | 3.1% |
| Other values (80) | 1357473 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3172957 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 385066 | 12.1% | |
| t | 251135 | 7.9% |
| s | 219566 | 6.9% |
| e | 176794 | 5.6% |
| n | 160850 | 5.1% |
| o | 145076 | 4.6% |
| i | 139802 | 4.4% |
| a | 135318 | 4.3% |
| P | 103035 | 3.2% |
| u | 98842 | 3.1% |
| Other values (80) | 1357473 |
cancelled
Boolean
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 73418 | |
| True | 47274 |
| Distinct | 47410 |
|---|---|
| Distinct (%) | 39.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Minimum | 2009-07-28 22:45:00+00:00 |
|---|---|
| Maximum | 2025-12-23 00:45:00+00:00 |
business_name
Categorical
HIGH CORRELATION 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 MiB |
| Scarb Physio & Health | |
|---|---|
| Osteopathy | Melton | |
| ⬅️ Front Desk Migration | |
| Osteopathy | Bacchus Marsh | |
| All Sorted Physiotherapy | |
| Other values (18) |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 21.396141 |
| Min length | 12 |
Characters and Unicode
| Total characters | 2582343 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Scarb Physio & Health |
|---|---|
| 2nd row | Scarb Physio & Health |
| 3rd row | Scarb Physio & Health |
| 4th row | Scarb Physio & Health |
| 5th row | Scarb Physio & Health |
Common Values
| Value | Count | Frequency (%) |
| Scarb Physio & Health | 24911 | |
| Osteopathy | Melton | 23208 | |
| ⬅️ Front Desk Migration | 16650 | |
| Osteopathy | Bacchus Marsh | 15055 | |
| All Sorted Physiotherapy | 9661 | 8.0% |
| Newport Psychology | 7289 | 6.0% |
| Scarb Remedial Massage | 6753 | 5.6% |
| Newport Physiotherapy | 6437 | 5.3% |
| Bosch Psychology | 4511 | 3.7% |
| PhysioCall Gladstone | 1842 | 1.5% |
| Other values (13) | 4375 | 3.6% |
Length
| Value | Count | Frequency (%) |
| 66509 | ||
| osteopathy | 38263 | 9.6% |
| scarb | 32403 | 8.1% |
| health | 25400 | 6.4% |
| melton | 25339 | 6.3% |
| physio | 24911 | 6.2% |
| physiotherapy | 17326 | 4.3% |
| ⬅️ | 16650 | 4.2% |
| front | 16650 | 4.2% |
| desk | 16650 | 4.2% |
| Other values (25) | 119029 |
Most occurring characters
| Value | Count | Frequency (%) |
| 278438 | 10.8% | |
| t | 203754 | 7.9% |
| o | 197072 | 7.6% |
| a | 189317 | 7.3% |
| h | 173678 | 6.7% |
| e | 171250 | 6.6% |
| s | 167484 | 6.5% |
| y | 124746 | 4.8% |
| r | 122194 | 4.7% |
| l | 96087 | 3.7% |
| Other values (37) | 858323 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2582343 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 278438 | 10.8% | |
| t | 203754 | 7.9% |
| o | 197072 | 7.6% |
| a | 189317 | 7.3% |
| h | 173678 | 6.7% |
| e | 171250 | 6.6% |
| s | 167484 | 6.5% |
| y | 124746 | 4.8% |
| r | 122194 | 4.7% |
| l | 96087 | 3.7% |
| Other values (37) | 858323 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2582343 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 278438 | 10.8% | |
| t | 203754 | 7.9% |
| o | 197072 | 7.6% |
| a | 189317 | 7.3% |
| h | 173678 | 6.7% |
| e | 171250 | 6.6% |
| s | 167484 | 6.5% |
| y | 124746 | 4.8% |
| r | 122194 | 4.7% |
| l | 96087 | 3.7% |
| Other values (37) | 858323 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2582343 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 278438 | 10.8% | |
| t | 203754 | 7.9% |
| o | 197072 | 7.6% |
| a | 189317 | 7.3% |
| h | 173678 | 6.7% |
| e | 171250 | 6.6% |
| s | 167484 | 6.5% |
| y | 124746 | 4.8% |
| r | 122194 | 4.7% |
| l | 96087 | 3.7% |
| Other values (37) | 858323 |
concession_type
Categorical
HIGH CORRELATION  IMBALANCE  MISSING 
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 97703 |
| Missing (%) | 81.0% |
| Memory size | 1.8 MiB |
| Concession Discount | |
|---|---|
| Concession / Pension Card Holder | |
| VIP Discount | |
| Student | 1294 |
| VIP + Concession Discount | 315 |
| Other values (12) | 137 |
Length
| Max length | 32 |
|---|---|
| Median length | 19 |
| Mean length | 21.06129 |
| Min length | 3 |
Characters and Unicode
| Total characters | 484178 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Concession / Pension Card Holder |
|---|---|
| 2nd row | Concession / Pension Card Holder |
| 3rd row | Concession / Pension Card Holder |
| 4th row | Concession / Pension Card Holder |
| 5th row | Concession / Pension Card Holder |
Common Values
| Value | Count | Frequency (%) |
| Concession Discount | 13652 | 11.3% |
| Concession / Pension Card Holder | 5724 | 4.7% |
| VIP Discount | 1867 | 1.5% |
| Student | 1294 | 1.1% |
| VIP + Concession Discount | 315 | 0.3% |
| WorkCover | 27 | < 0.1% |
| Patient is under 18 years old | 22 | < 0.1% |
| Students | Under 18 Years Old | 19 | < 0.1% |
| Medicare | 16 | < 0.1% |
| Third Party | 13 | < 0.1% |
| Other values (7) | 40 | < 0.1% |
| (Missing) | 97703 |
Length
| Value | Count | Frequency (%) |
| concession | 19708 | |
| discount | 15834 | |
| 6065 | 9.7% | |
| card | 5734 | 9.2% |
| pension | 5724 | 9.1% |
| holder | 5724 | 9.1% |
| vip | 2182 | 3.5% |
| student | 1294 | 2.1% |
| under | 41 | 0.1% |
| old | 41 | 0.1% |
| Other values (15) | 254 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 68120 | |
| o | 66809 | |
| s | 61102 | |
| i | 41361 | |
| 39612 | ||
| c | 35561 | |
| e | 32685 | |
| C | 25472 | 5.3% |
| t | 18521 | 3.8% |
| u | 17171 | 3.5% |
| Other values (27) | 77764 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 484178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 68120 | |
| o | 66809 | |
| s | 61102 | |
| i | 41361 | |
| 39612 | ||
| c | 35561 | |
| e | 32685 | |
| C | 25472 | 5.3% |
| t | 18521 | 3.8% |
| u | 17171 | 3.5% |
| Other values (27) | 77764 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 484178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 68120 | |
| o | 66809 | |
| s | 61102 | |
| i | 41361 | |
| 39612 | ||
| c | 35561 | |
| e | 32685 | |
| C | 25472 | 5.3% |
| t | 18521 | 3.8% |
| u | 17171 | 3.5% |
| Other values (27) | 77764 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 484178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 68120 | |
| o | 66809 | |
| s | 61102 | |
| i | 41361 | |
| 39612 | ||
| c | 35561 | |
| e | 32685 | |
| C | 25472 | 5.3% |
| t | 18521 | 3.8% |
| u | 17171 | 3.5% |
| Other values (27) | 77764 |
customer_type
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 77964 |
| Missing (%) | 64.6% |
| Memory size | 1.8 MiB |
| WorkCover | |
|---|---|
| Medicare Referrals | |
| NDIS | |
| CDM | |
| Concession / Pension Card Holder | |
| Other values (27) |
Length
| Max length | 32 |
|---|---|
| Median length | 29 |
| Mean length | 11.55968 |
| Min length | 3 |
Characters and Unicode
| Total characters | 493922 |
|---|---|
| Distinct characters | 46 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Concession / Pension Card Holder |
|---|---|
| 2nd row | Concession / Pension Card Holder |
| 3rd row | Concession / Pension Card Holder |
| 4th row | Concession / Pension Card Holder |
| 5th row | Concession / Pension Card Holder |
Common Values
| Value | Count | Frequency (%) |
| WorkCover | 6918 | 5.7% |
| Medicare Referrals | 5887 | 4.9% |
| NDIS | 4528 | 3.8% |
| CDM | 4438 | 3.7% |
| Concession / Pension Card Holder | 4330 | 3.6% |
| DVA | 4191 | 3.5% |
| DVA Card Holder | 2891 | 2.4% |
| Medicare | 1883 | 1.6% |
| NDIS Customer | 1489 | 1.2% |
| Third Party | 1445 | 1.2% |
| Other values (22) | 4728 | 3.9% |
| (Missing) | 77964 |
Length
| Value | Count | Frequency (%) |
| medicare | 7770 | |
| card | 7225 | |
| holder | 7221 | |
| dva | 7082 | |
| workcover | 6952 | 8.8% |
| ndis | 6017 | 7.6% |
| referrals | 5887 | 7.4% |
| 5122 | 6.4% | |
| cdm | 4438 | 5.6% |
| concession | 4341 | 5.5% |
| Other values (34) | 17386 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 56373 | 11.4% |
| r | 55221 | 11.2% |
| 37307 | 7.6% | |
| o | 36908 | 7.5% |
| d | 26129 | 5.3% |
| C | 25948 | 5.3% |
| a | 25190 | 5.1% |
| s | 21736 | 4.4% |
| i | 20049 | 4.1% |
| n | 19815 | 4.0% |
| Other values (36) | 169246 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 493922 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 56373 | 11.4% |
| r | 55221 | 11.2% |
| 37307 | 7.6% | |
| o | 36908 | 7.5% |
| d | 26129 | 5.3% |
| C | 25948 | 5.3% |
| a | 25190 | 5.1% |
| s | 21736 | 4.4% |
| i | 20049 | 4.1% |
| n | 19815 | 4.0% |
| Other values (36) | 169246 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 493922 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 56373 | 11.4% |
| r | 55221 | 11.2% |
| 37307 | 7.6% | |
| o | 36908 | 7.5% |
| d | 26129 | 5.3% |
| C | 25948 | 5.3% |
| a | 25190 | 5.1% |
| s | 21736 | 4.4% |
| i | 20049 | 4.1% |
| n | 19815 | 4.0% |
| Other values (36) | 169246 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 493922 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 56373 | 11.4% |
| r | 55221 | 11.2% |
| 37307 | 7.6% | |
| o | 36908 | 7.5% |
| d | 26129 | 5.3% |
| C | 25948 | 5.3% |
| a | 25190 | 5.1% |
| s | 21736 | 4.4% |
| i | 20049 | 4.1% |
| n | 19815 | 4.0% |
| Other values (36) | 169246 |
title
Categorical
IMBALANCE  MISSING 
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 53560 |
| Missing (%) | 44.4% |
| Memory size | 1.8 MiB |
| Mr | |
|---|---|
| Mrs | |
| Ms | |
| Miss | |
| 1818 | |
| Other values (23) |
Length
| Max length | 15 |
|---|---|
| Median length | 2 |
| Mean length | 2.5545046 |
| Min length | 1 |
Characters and Unicode
| Total characters | 171489 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Mrs |
|---|---|
| 2nd row | Mrs |
| 3rd row | Mr |
| 4th row | Mr |
| 5th row | Mr |
Common Values
| Value | Count | Frequency (%) |
| Mr | 22269 | |
| Mrs | 18159 | 15.0% |
| Ms | 14851 | 12.3% |
| Miss | 7712 | 6.4% |
| 1818 | 1.5% | |
| Master | 956 | 0.8% |
| Dr | 616 | 0.5% |
| MISS | 291 | 0.2% |
| Mrs | 128 | 0.1% |
| Mr | 112 | 0.1% |
| Other values (18) | 220 | 0.2% |
| (Missing) | 53560 |
Length
| Value | Count | Frequency (%) |
| mr | 22414 | |
| mrs | 18289 | |
| ms | 14884 | |
| miss | 8004 | 12.3% |
| master | 1057 | 1.6% |
| dr | 616 | 0.9% |
| sr | 12 | < 0.1% |
| no | 10 | < 0.1% |
| title | 10 | < 0.1% |
| please | 10 | < 0.1% |
| Other values (5) | 12 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 64656 | |
| s | 49575 | |
| r | 42281 | |
| i | 7724 | 4.5% |
| 2227 | 1.3% | |
| e | 994 | 0.6% |
| t | 983 | 0.6% |
| a | 974 | 0.6% |
| S | 697 | 0.4% |
| D | 616 | 0.4% |
| Other values (16) | 762 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171489 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 64656 | |
| s | 49575 | |
| r | 42281 | |
| i | 7724 | 4.5% |
| 2227 | 1.3% | |
| e | 994 | 0.6% |
| t | 983 | 0.6% |
| a | 974 | 0.6% |
| S | 697 | 0.4% |
| D | 616 | 0.4% |
| Other values (16) | 762 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171489 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 64656 | |
| s | 49575 | |
| r | 42281 | |
| i | 7724 | 4.5% |
| 2227 | 1.3% | |
| e | 994 | 0.6% |
| t | 983 | 0.6% |
| a | 974 | 0.6% |
| S | 697 | 0.4% |
| D | 616 | 0.4% |
| Other values (16) | 762 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171489 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 64656 | |
| s | 49575 | |
| r | 42281 | |
| i | 7724 | 4.5% |
| 2227 | 1.3% | |
| e | 994 | 0.6% |
| t | 983 | 0.6% |
| a | 974 | 0.6% |
| S | 697 | 0.4% |
| D | 616 | 0.4% |
| Other values (16) | 762 | 0.4% |
state
Categorical
IMBALANCE  MISSING 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 58312 |
| Missing (%) | 48.3% |
| Memory size | 1.8 MiB |
| QLD | |
|---|---|
| VIC | 3541 |
| Qld | 2269 |
| Vic | 576 |
| NSW | 487 |
| Other values (22) | 814 |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 3.0088971 |
| Min length | 2 |
Characters and Unicode
| Total characters | 187695 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | QLD |
|---|---|
| 2nd row | QLD |
| 3rd row | QLD |
| 4th row | QLD |
| 5th row | QLD |
Common Values
| Value | Count | Frequency (%) |
| QLD | 54693 | |
| VIC | 3541 | 2.9% |
| Qld | 2269 | 1.9% |
| Vic | 576 | 0.5% |
| NSW | 487 | 0.4% |
| QLD | 292 | 0.2% |
| VIc | 158 | 0.1% |
| VIC | 105 | 0.1% |
| VIC | 58 | < 0.1% |
| Qld | 57 | < 0.1% |
| Other values (17) | 144 | 0.1% |
| (Missing) | 58312 |
Length
| Value | Count | Frequency (%) |
| qld | 57346 | |
| vic | 4488 | 7.2% |
| nsw | 487 | 0.8% |
| wa | 25 | < 0.1% |
| act | 9 | < 0.1% |
| sa | 8 | < 0.1% |
| melton | 4 | < 0.1% |
| nt | 3 | < 0.1% |
| viv | 3 | < 0.1% |
| west | 3 | < 0.1% |
| Other values (7) | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 57313 | |
| L | 54987 | |
| D | 54985 | |
| V | 4446 | 2.4% |
| I | 3865 | 2.1% |
| C | 3713 | 2.0% |
| l | 2366 | 1.3% |
| d | 2365 | 1.3% |
| c | 784 | 0.4% |
| i | 628 | 0.3% |
| Other values (28) | 2243 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 187695 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 57313 | |
| L | 54987 | |
| D | 54985 | |
| V | 4446 | 2.4% |
| I | 3865 | 2.1% |
| C | 3713 | 2.0% |
| l | 2366 | 1.3% |
| d | 2365 | 1.3% |
| c | 784 | 0.4% |
| i | 628 | 0.3% |
| Other values (28) | 2243 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 187695 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 57313 | |
| L | 54987 | |
| D | 54985 | |
| V | 4446 | 2.4% |
| I | 3865 | 2.1% |
| C | 3713 | 2.0% |
| l | 2366 | 1.3% |
| d | 2365 | 1.3% |
| c | 784 | 0.4% |
| i | 628 | 0.3% |
| Other values (28) | 2243 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 187695 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 57313 | |
| L | 54987 | |
| D | 54985 | |
| V | 4446 | 2.4% |
| I | 3865 | 2.1% |
| C | 3713 | 2.0% |
| l | 2366 | 1.3% |
| d | 2365 | 1.3% |
| c | 784 | 0.4% |
| i | 628 | 0.3% |
| Other values (28) | 2243 | 1.2% |
date_of_birth
Date
| Distinct | 14588 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 925 |
| Missing (%) | 0.8% |
| Memory size | 1.8 MiB |
| Minimum | 1909-01-31 00:00:00 |
|---|---|
| Maximum | 2024-04-01 00:00:00 |
sex
Categorical
IMBALANCE  MISSING 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 53523 |
| Missing (%) | 44.3% |
| Memory size | 1.8 MiB |
| Female | |
|---|---|
| Male | |
| female | 186 |
| male | 81 |
| AMAB | 22 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.3172148 |
| Min length | 4 |
Characters and Unicode
| Total characters | 357152 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Female |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Female | 44050 | |
| Male | 22826 | |
| female | 186 | 0.2% |
| male | 81 | 0.1% |
| AMAB | 22 | < 0.1% |
| Other | 4 | < 0.1% |
| (Missing) | 53523 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 44236 | |
| male | 22907 | |
| amab | 22 | < 0.1% |
| other | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 111383 | |
| a | 67143 | |
| l | 67143 | |
| m | 44317 | 12.4% |
| F | 44050 | 12.3% |
| M | 22848 | 6.4% |
| f | 186 | 0.1% |
| A | 44 | < 0.1% |
| B | 22 | < 0.1% |
| O | 4 | < 0.1% |
| Other values (3) | 12 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 357152 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 111383 | |
| a | 67143 | |
| l | 67143 | |
| m | 44317 | 12.4% |
| F | 44050 | 12.3% |
| M | 22848 | 6.4% |
| f | 186 | 0.1% |
| A | 44 | < 0.1% |
| B | 22 | < 0.1% |
| O | 4 | < 0.1% |
| Other values (3) | 12 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 357152 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 111383 | |
| a | 67143 | |
| l | 67143 | |
| m | 44317 | 12.4% |
| F | 44050 | 12.3% |
| M | 22848 | 6.4% |
| f | 186 | 0.1% |
| A | 44 | < 0.1% |
| B | 22 | < 0.1% |
| O | 4 | < 0.1% |
| Other values (3) | 12 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 357152 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 111383 | |
| a | 67143 | |
| l | 67143 | |
| m | 44317 | 12.4% |
| F | 44050 | 12.3% |
| M | 22848 | 6.4% |
| f | 186 | 0.1% |
| A | 44 | < 0.1% |
| B | 22 | < 0.1% |
| O | 4 | < 0.1% |
| Other values (3) | 12 | < 0.1% |
post_code
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 56784 |
|---|---|
| Missing (%) | 47.0% |
| Memory size | 1.8 MiB |
city
Text
MISSING 
| Distinct | 633 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 56373 |
| Missing (%) | 46.7% |
| Memory size | 1.8 MiB |
Length
| Max length | 27 |
|---|---|
| Median length | 21 |
| Mean length | 9.4763756 |
| Min length | 2 |
Characters and Unicode
| Total characters | 609511 |
|---|---|
| Distinct characters | 68 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 151 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | KIPPA RING |
|---|---|
| 2nd row | KIPPA RING |
| 3rd row | Scarborough |
| 4th row | Scarborough |
| 5th row | Scarborough |
| Value | Count | Frequency (%) |
| scarborough | 14138 | |
| newport | 8383 | 10.8% |
| redcliffe | 6613 | 8.5% |
| gladstone | 4965 | 6.4% |
| margate | 3067 | 4.0% |
| bay | 2702 | 3.5% |
| deception | 2686 | 3.5% |
| clontarf | 2641 | 3.4% |
| kippa | 2180 | 2.8% |
| ring | 2180 | 2.8% |
| Other values (430) | 27901 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 52609 | 8.6% |
| r | 46177 | 7.6% |
| e | 38746 | 6.4% |
| a | 37660 | 6.2% |
| t | 23336 | 3.8% |
| c | 23088 | 3.8% |
| g | 21967 | 3.6% |
| S | 21263 | 3.5% |
| i | 20719 | 3.4% |
| l | 20062 | 3.3% |
| Other values (58) | 303884 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 609511 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 52609 | 8.6% |
| r | 46177 | 7.6% |
| e | 38746 | 6.4% |
| a | 37660 | 6.2% |
| t | 23336 | 3.8% |
| c | 23088 | 3.8% |
| g | 21967 | 3.6% |
| S | 21263 | 3.5% |
| i | 20719 | 3.4% |
| l | 20062 | 3.3% |
| Other values (58) | 303884 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 609511 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 52609 | 8.6% |
| r | 46177 | 7.6% |
| e | 38746 | 6.4% |
| a | 37660 | 6.2% |
| t | 23336 | 3.8% |
| c | 23088 | 3.8% |
| g | 21967 | 3.6% |
| S | 21263 | 3.5% |
| i | 20719 | 3.4% |
| l | 20062 | 3.3% |
| Other values (58) | 303884 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 609511 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 52609 | 8.6% |
| r | 46177 | 7.6% |
| e | 38746 | 6.4% |
| a | 37660 | 6.2% |
| t | 23336 | 3.8% |
| c | 23088 | 3.8% |
| g | 21967 | 3.6% |
| S | 21263 | 3.5% |
| i | 20719 | 3.4% |
| l | 20062 | 3.3% |
| Other values (58) | 303884 |
occupation
Text
MISSING 
| Distinct | 3136 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 50304 |
| Missing (%) | 41.7% |
| Memory size | 1.8 MiB |
Length
| Max length | 56 |
|---|---|
| Median length | 44 |
| Mean length | 12.023754 |
| Min length | 1 |
Characters and Unicode
| Total characters | 846328 |
|---|---|
| Distinct characters | 77 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 437 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | Retired |
|---|---|
| 2nd row | Retired |
| 3rd row | Draftsman |
| 4th row | Draftsman |
| 5th row | Draftsman |
| Value | Count | Frequency (%) |
| retired | 13366 | 11.8% |
| manager | 4049 | 3.6% |
| student | 3974 | 3.5% |
| teacher | 3405 | 3.0% |
| worker | 3295 | 2.9% |
| nurse | 2311 | 2.0% |
| support | 2134 | 1.9% |
| officer | 2106 | 1.9% |
| assistant | 1929 | 1.7% |
| driver | 1792 | 1.6% |
| Other values (1768) | 74870 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 113390 | |
| r | 84824 | 10.0% |
| t | 68858 | 8.1% |
| i | 64207 | 7.6% |
| a | 51824 | 6.1% |
| n | 46908 | 5.5% |
| 43876 | 5.2% | |
| o | 38416 | 4.5% |
| s | 35944 | 4.2% |
| d | 32063 | 3.8% |
| Other values (67) | 266018 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 846328 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 113390 | |
| r | 84824 | 10.0% |
| t | 68858 | 8.1% |
| i | 64207 | 7.6% |
| a | 51824 | 6.1% |
| n | 46908 | 5.5% |
| 43876 | 5.2% | |
| o | 38416 | 4.5% |
| s | 35944 | 4.2% |
| d | 32063 | 3.8% |
| Other values (67) | 266018 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 846328 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 113390 | |
| r | 84824 | 10.0% |
| t | 68858 | 8.1% |
| i | 64207 | 7.6% |
| a | 51824 | 6.1% |
| n | 46908 | 5.5% |
| 43876 | 5.2% | |
| o | 38416 | 4.5% |
| s | 35944 | 4.2% |
| d | 32063 | 3.8% |
| Other values (67) | 266018 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 846328 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 113390 | |
| r | 84824 | 10.0% |
| t | 68858 | 8.1% |
| i | 64207 | 7.6% |
| a | 51824 | 6.1% |
| n | 46908 | 5.5% |
| 43876 | 5.2% | |
| o | 38416 | 4.5% |
| s | 35944 | 4.2% |
| d | 32063 | 3.8% |
| Other values (67) | 266018 |
referred
Boolean
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 80292 | |
| True | 40400 |
total_closed_invoices_before_appointemnt
Real number (ℝ)
HIGH CORRELATION  MISSING  ZEROS 
| Distinct | 174 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 80258 |
| Missing (%) | 66.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.050354 |
| Minimum | 0 |
|---|---|
| Maximum | 305 |
| Zeros | 10447 |
| Zeros (%) | 8.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 12 |
| 95-th percentile | 58 |
| Maximum | 305 |
| Range | 305 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 25.594842 |
|---|---|
| Coefficient of variation (CV) | 2.1239909 |
| Kurtosis | 34.544534 |
| Mean | 12.050354 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 5.0288834 |
| Sum | 487244 |
| Variance | 655.09592 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10447 | 8.7% |
| 1 | 3817 | 3.2% |
| 2 | 3279 | 2.7% |
| 3 | 2916 | 2.4% |
| 4 | 2114 | 1.8% |
| 5 | 1751 | 1.5% |
| 6 | 1379 | 1.1% |
| 7 | 1062 | 0.9% |
| 8 | 1048 | 0.9% |
| 9 | 978 | 0.8% |
| Other values (164) | 11643 | 9.6% |
| (Missing) | 80258 |
| Value | Count | Frequency (%) |
| 0 | 10447 | |
| 1 | 3817 | 3.2% |
| 2 | 3279 | 2.7% |
| 3 | 2916 | 2.4% |
| 4 | 2114 | 1.8% |
| 5 | 1751 | 1.5% |
| 6 | 1379 | 1.1% |
| 7 | 1062 | 0.9% |
| 8 | 1048 | 0.9% |
| 9 | 978 | 0.8% |
| Value | Count | Frequency (%) |
| 305 | 4 | |
| 303 | 4 | |
| 297 | 4 | |
| 295 | 4 | |
| 294 | 4 | |
| 286 | 4 | |
| 280 | 4 | |
| 278 | 4 | |
| 275 | 4 | |
| 273 | 4 |
| appointment_status | business_name | cancelled | case_type | concession_type | customer_type | day_of_week | month_of_year | notice | opened_case_name | patient_status | patient_type | percentage_good_appointments_and_missed_appointments_before_can | referred | session_left | sex | state | time_of_day | title | total_closed_invoices_before_appointemnt | total_cxl_appointments_before_cancelled_appointment | total_good_appointments_before_cancelled_appointment | total_open_invoices_before_appointemnt | week_of_year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| appointment_status | 1.000 | 0.508 | 0.742 | 0.043 | 0.398 | 0.333 | 0.059 | 0.052 | 0.406 | 0.166 | 0.160 | 0.728 | 0.604 | 0.104 | 0.008 | 0.065 | 0.181 | 0.086 | 0.153 | 0.077 | 0.626 | 0.731 | 0.342 | -0.015 |
| business_name | 0.508 | 1.000 | 0.620 | 0.195 | 0.505 | 0.293 | 0.121 | 0.082 | 0.175 | 0.290 | 0.099 | 0.321 | -0.216 | 0.794 | -0.021 | 0.087 | 0.251 | 0.176 | 0.147 | 0.439 | -0.194 | -0.119 | -0.054 | 0.010 |
| cancelled | 0.742 | 0.620 | 1.000 | 0.041 | 0.507 | 0.387 | 0.076 | 0.050 | 0.612 | 0.251 | 0.294 | 0.929 | 0.719 | 0.166 | 0.086 | 0.053 | 0.239 | 0.092 | 0.197 | NaN | 0.719 | 0.900 | 0.305 | -0.033 |
| case_type | 0.043 | 0.195 | 0.041 | 1.000 | 0.104 | 0.272 | 0.071 | 0.024 | 0.000 | 0.519 | 0.026 | 0.045 | -0.034 | 0.122 | NaN | 0.015 | 0.035 | 0.061 | 0.036 | 0.008 | -0.031 | -0.025 | -0.012 | -0.013 |
| concession_type | 0.398 | 0.505 | 0.507 | 0.104 | 1.000 | 0.651 | 0.075 | 0.054 | -0.314 | 0.268 | 0.086 | 0.244 | -0.250 | 0.800 | 0.001 | 0.087 | 0.318 | 0.157 | 0.191 | -0.184 | -0.253 | -0.312 | -0.001 | 0.000 |
| customer_type | 0.333 | 0.293 | 0.387 | 0.272 | 0.651 | 1.000 | 0.129 | 0.068 | -0.047 | 0.267 | 0.090 | 0.201 | 0.009 | 0.543 | 0.085 | 0.239 | 0.268 | 0.188 | 0.203 | 0.071 | 0.021 | -0.005 | 0.091 | -0.016 |
| day_of_week | 0.059 | 0.121 | 0.076 | 0.071 | 0.075 | 0.129 | 1.000 | 0.033 | 0.027 | 0.054 | 0.037 | 0.046 | 0.008 | 0.115 | -0.016 | 0.039 | 0.059 | 0.146 | 0.049 | 0.055 | 0.012 | 0.023 | -0.022 | -0.012 |
| month_of_year | 0.052 | 0.082 | 0.050 | 0.024 | 0.054 | 0.068 | 0.033 | 1.000 | -0.040 | 0.050 | 0.055 | 0.048 | 0.003 | 0.078 | 0.002 | 0.013 | 0.045 | 0.020 | 0.030 | -0.002 | 0.006 | -0.022 | -0.005 | 0.298 |
| notice | 0.406 | 0.175 | 0.612 | 0.000 | -0.314 | -0.047 | 0.027 | -0.040 | 1.000 | 0.062 | 0.033 | 0.190 | 0.198 | 0.159 | 0.074 | 0.017 | 0.043 | 0.045 | 0.136 | 0.372 | 0.231 | 0.578 | 0.288 | -0.044 |
| opened_case_name | 0.166 | 0.290 | 0.251 | 0.519 | 0.268 | 0.267 | 0.054 | 0.050 | 0.062 | 1.000 | 0.035 | 0.165 | -0.140 | 0.236 | 0.899 | 0.029 | 0.144 | 0.077 | 0.077 | -0.037 | -0.143 | -0.153 | 0.004 | -0.015 |
| patient_status | 0.160 | 0.099 | 0.294 | 0.026 | 0.086 | 0.090 | 0.037 | 0.055 | 0.033 | 0.035 | 1.000 | 0.160 | 0.071 | 0.141 | 0.013 | 0.029 | 0.041 | 0.032 | 0.035 | 0.066 | 0.074 | 0.109 | -0.034 | -0.058 |
| patient_type | 0.728 | 0.321 | 0.929 | 0.045 | 0.244 | 0.201 | 0.046 | 0.048 | 0.190 | 0.165 | 0.160 | 1.000 | 0.691 | 0.182 | 0.075 | 0.035 | 0.106 | 0.068 | 0.095 | 0.195 | 0.708 | 0.953 | 0.312 | -0.014 |
| percentage_good_appointments_and_missed_appointments_before_can | 0.604 | -0.216 | 0.719 | -0.034 | -0.250 | 0.009 | 0.008 | 0.003 | 0.198 | -0.140 | 0.071 | 0.691 | 1.000 | 0.154 | 0.062 | 0.046 | 0.071 | 0.058 | 0.113 | -0.121 | 0.982 | 0.729 | 0.320 | -0.001 |
| referred | 0.104 | 0.794 | 0.166 | 0.122 | 0.800 | 0.543 | 0.115 | 0.078 | 0.159 | 0.236 | 0.141 | 0.182 | 0.154 | 1.000 | -0.018 | 0.058 | 0.329 | 0.156 | 0.271 | 0.276 | 0.078 | 0.167 | 0.051 | 0.007 |
| session_left | 0.008 | -0.021 | 0.086 | NaN | 0.001 | 0.085 | -0.016 | 0.002 | 0.074 | 0.899 | 0.013 | 0.075 | 0.062 | -0.018 | 1.000 | 0.102 | 0.043 | 0.044 | 0.092 | -0.115 | 0.048 | 0.045 | 0.073 | -0.007 |
| sex | 0.065 | 0.087 | 0.053 | 0.015 | 0.087 | 0.239 | 0.039 | 0.013 | 0.017 | 0.029 | 0.029 | 0.035 | 0.046 | 0.058 | 0.102 | 1.000 | 0.101 | 0.021 | 0.495 | 0.015 | -0.062 | -0.037 | 0.043 | 0.010 |
| state | 0.181 | 0.251 | 0.239 | 0.035 | 0.318 | 0.268 | 0.059 | 0.045 | 0.043 | 0.144 | 0.041 | 0.106 | 0.071 | 0.329 | 0.043 | 0.101 | 1.000 | 0.096 | 0.074 | -0.084 | -0.165 | -0.173 | 0.001 | -0.032 |
| time_of_day | 0.086 | 0.176 | 0.092 | 0.061 | 0.157 | 0.188 | 0.146 | 0.020 | 0.045 | 0.077 | 0.032 | 0.068 | 0.058 | 0.156 | 0.044 | 0.021 | 0.096 | 1.000 | 0.077 | 0.097 | 0.030 | 0.048 | 0.015 | 0.002 |
| title | 0.153 | 0.147 | 0.197 | 0.036 | 0.191 | 0.203 | 0.049 | 0.030 | 0.136 | 0.077 | 0.035 | 0.095 | 0.113 | 0.271 | 0.092 | 0.495 | 0.074 | 0.077 | 1.000 | 0.063 | 0.105 | 0.114 | -0.012 | -0.028 |
| total_closed_invoices_before_appointemnt | 0.077 | 0.439 | NaN | 0.008 | -0.184 | 0.071 | 0.055 | -0.002 | 0.372 | -0.037 | 0.066 | 0.195 | -0.121 | 0.276 | -0.115 | 0.015 | -0.084 | 0.097 | 0.063 | 1.000 | 0.266 | 0.772 | NaN | 0.022 |
| total_cxl_appointments_before_cancelled_appointment | 0.626 | -0.194 | 0.719 | -0.031 | -0.253 | 0.021 | 0.012 | 0.006 | 0.231 | -0.143 | 0.074 | 0.708 | 0.982 | 0.078 | 0.048 | -0.062 | -0.165 | 0.030 | 0.105 | 0.266 | 1.000 | 0.780 | 0.324 | 0.005 |
| total_good_appointments_before_cancelled_appointment | 0.731 | -0.119 | 0.900 | -0.025 | -0.312 | -0.005 | 0.023 | -0.022 | 0.578 | -0.153 | 0.109 | 0.953 | 0.729 | 0.167 | 0.045 | -0.037 | -0.173 | 0.048 | 0.114 | 0.772 | 0.780 | 1.000 | 0.325 | -0.013 |
| total_open_invoices_before_appointemnt | 0.342 | -0.054 | 0.305 | -0.012 | -0.001 | 0.091 | -0.022 | -0.005 | 0.288 | 0.004 | -0.034 | 0.312 | 0.320 | 0.051 | 0.073 | 0.043 | 0.001 | 0.015 | -0.012 | NaN | 0.324 | 0.325 | 1.000 | -0.008 |
| week_of_year | -0.015 | 0.010 | -0.033 | -0.013 | 0.000 | -0.016 | -0.012 | 0.298 | -0.044 | -0.015 | -0.058 | -0.014 | -0.001 | 0.007 | -0.007 | 0.010 | -0.032 | 0.002 | -0.028 | 0.022 | 0.005 | -0.013 | -0.008 | 1.000 |
| opened_case_name | total_open_invoices_before_appointemnt | total_good_appointments_before_cancelled_appointment | total_cxl_appointments_before_cancelled_appointment | percentage_good_appointments_and_missed_appointments_before_can | patient_status | patient_type | time_of_day | day_of_week | month_of_year | week_of_year | appointment_status | notice | session_left | case_type | cancelled_at | appointment_type | billable_item | category | cancelled | appointment_start_time | business_name | concession_type | customer_type | title | state | date_of_birth | sex | post_code | city | occupation | referred | total_closed_invoices_before_appointemnt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Expired | 0.0 | 1.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Morning | Tuesday | November | 46.0 | Not Rebooked | 2.054167 | NaN | Unlimited | 2022-11-14 22:26:45+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-11-15 00:30:00+00 | Scarb Physio & Health | Concession / Pension Card Holder | Concession / Pension Card Holder | Mrs | QLD | 1928-07-20 | Female | 4020.0 | KIPPA RING | Retired | Yes | NaN |
| 1 | Expired | 0.0 | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Morning | Thursday | October | 42.0 | Not Rebooked | 0.000000 | NaN | Unlimited | NaN | 1. ⭐️ Physiotherapy - 45 Minute Initial Consult | Physiotherapy - 45 Minute Initial Consult | A | PHYSIOTHERAPY | No | 2022-10-20 00:30:00+00 | Scarb Physio & Health | Concession / Pension Card Holder | Concession / Pension Card Holder | Mrs | QLD | 1928-07-20 | Female | 4020.0 | KIPPA RING | Retired | Yes | NaN |
| 2 | Opened | 0.0 | 8.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Friday | October | 43.0 | Rebooked | 26.688333 | NaN | Unlimited | 2022-10-27 00:48:42+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-10-28 03:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 3 | Expired | 0.0 | 8.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Friday | October | 43.0 | Rebooked | 26.688333 | NaN | Unlimited | 2022-10-27 00:48:42+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-10-28 03:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 5 | Opened | 0.0 | 9.0 | 1 | 10.0 | Admin Follow Up | Recurring | Morning | Monday | March | 13.0 | Not Rebooked | 1.770556 | NaN | Unlimited | 2024-03-24 21:43:46+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2024-03-24 23:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 6 | Expired | 0.0 | 9.0 | 1 | 10.0 | Admin Follow Up | Recurring | Morning | Monday | March | 13.0 | Not Rebooked | 1.770556 | NaN | Unlimited | 2024-03-24 21:43:46+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2024-03-24 23:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 8 | Expired | 0.0 | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Morning | Monday | March | 13.0 | Not Rebooked | 0.000000 | NaN | Unlimited | NaN | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | No | 2022-03-28 01:00:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 9 | Opened | 0.0 | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Morning | Saturday | October | 41.0 | Not Rebooked | 0.000000 | NaN | Unlimited | NaN | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | No | 2022-10-14 23:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 11 | Expired | 0.0 | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Morning | Tuesday | April | 15.0 | Not Rebooked | 0.000000 | NaN | Unlimited | NaN | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | No | 2022-04-11 21:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| 12 | Expired | 0.0 | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Morning | Monday | March | 12.0 | Not Rebooked | 0.000000 | NaN | Unlimited | NaN | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | No | 2022-03-21 00:30:00+00 | Scarb Physio & Health | NaN | NaN | Mr | QLD | 1956-06-19 | Male | 4020.0 | Scarborough | Draftsman | Yes | NaN |
| opened_case_name | total_open_invoices_before_appointemnt | total_good_appointments_before_cancelled_appointment | total_cxl_appointments_before_cancelled_appointment | percentage_good_appointments_and_missed_appointments_before_can | patient_status | patient_type | time_of_day | day_of_week | month_of_year | week_of_year | appointment_status | notice | session_left | case_type | cancelled_at | appointment_type | billable_item | category | cancelled | appointment_start_time | business_name | concession_type | customer_type | title | state | date_of_birth | sex | post_code | city | occupation | referred | total_closed_invoices_before_appointemnt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160213 | Expired | NaN | 12.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Tuesday | February | 7.0 | Not Rebooked | 28.200833 | 3.0 | Max Sessions | 2023-02-13 01:47:57+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2023-02-14 06:00:00+00 | Scarb Physio & Health | NaN | NaN | Mrs | QLD | 1976-06-05 | Female | 4020.0 | Scarborough | Validation Engineer | Yes | 12.0 |
| 160214 | Opened | NaN | 12.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Tuesday | February | 7.0 | Not Rebooked | 28.200833 | NaN | Unlimited | 2023-02-13 01:47:57+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2023-02-14 06:00:00+00 | Scarb Physio & Health | NaN | NaN | Mrs | QLD | 1976-06-05 | Female | 4020.0 | Scarborough | Validation Engineer | Yes | 12.0 |
| 160215 | Expired | NaN | 12.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Tuesday | February | 7.0 | Not Rebooked | 28.200833 | NaN | Unlimited | 2023-02-13 01:47:57+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2023-02-14 06:00:00+00 | Scarb Physio & Health | NaN | NaN | Mrs | QLD | 1976-06-05 | Female | 4020.0 | Scarborough | Validation Engineer | Yes | 12.0 |
| 160216 | Closed | NaN | 4.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Monday | June | 23.0 | Rebooked | 20.549167 | 0.0 | Max Sessions | 2023-06-04 10:17:03+00 | 2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher) | PhysioCall - Get Out Of Pain Plan (GOOPP) | B | Get Out Of Pain Pre-Paid Sessions - (GOOPP) | Yes | 2023-06-05 06:50:00+00 | PhysioCall Gladstone | NaN | NaN | Mr | QLD | 2000-07-26 | NaN | 4680.0 | Glen Eden | Electrician | Yes | 4.0 |
| 160217 | Expired | NaN | 0.0 | 0 | 0.0 | Not Yet Actioned | New To Clinic | Afternoon | Thursday | October | 41.0 | Not Rebooked | 28.228056 | NaN | Unlimited | 2022-10-12 01:01:19+00 | 1. ⭐️ Physiotherapy - 45 Minute Initial Consult | Physiotherapy - 45 Minute Initial Consult | A | PHYSIOTHERAPY | Yes | 2022-10-13 05:15:00+00 | Scarb Physio & Health | NaN | NaN | Mr | NaN | 1983-05-03 | Male | NaN | NaN | NaN | No | 0.0 |
| 160218 | Expired | NaN | 2.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Morning | Monday | October | 43.0 | Rebooked | 63.668056 | NaN | Unlimited | 2022-10-21 05:49:55+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-10-23 21:30:00+00 | Scarb Physio & Health | Student | Student | Mr | QLD | 2006-04-24 | Male | 4020.0 | KIPPA RING | Student | Yes | 2.0 |
| 160219 | Expired | NaN | 3.0 | 1 | 25.0 | Not Yet Actioned | Recurring | Morning | Thursday | November | 44.0 | Not Rebooked | 14.337778 | NaN | Unlimited | 2022-11-02 07:09:44+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-11-02 21:30:00+00 | Scarb Physio & Health | Student | Student | Mr | QLD | 2006-04-24 | Male | 4020.0 | KIPPA RING | Student | Yes | 3.0 |
| 160220 | Closed | NaN | 5.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Thursday | June | 24.0 | Rebooked | 28.778056 | 0.0 | Max Sessions | 2023-06-14 01:43:19+00 | 2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher) | PhysioCall - Get Out Of Pain Plan (GOOPP) | B | Get Out Of Pain Pre-Paid Sessions - (GOOPP) | Yes | 2023-06-15 06:30:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | NaN | 1981-12-10 | NaN | NaN | NaN | NaN | No | 4.0 |
| 160221 | Opened | NaN | 5.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Thursday | June | 24.0 | Rebooked | 28.778056 | 1.0 | Max Sessions | 2023-06-14 01:43:19+00 | 2. GOOPP Pre-paid 20 Minute Treatment (redeem voucher) | PhysioCall - Get Out Of Pain Plan (GOOPP) | B | Get Out Of Pain Pre-Paid Sessions - (GOOPP) | Yes | 2023-06-15 06:30:00+00 | PhysioCall Gladstone | NaN | NaN | NaN | NaN | 1981-12-10 | NaN | NaN | NaN | NaN | No | 4.0 |
| 160222 | Expired | NaN | 1.0 | 0 | 0.0 | Not Yet Actioned | Recurring | Afternoon | Friday | October | 41.0 | Not Rebooked | 24.880556 | NaN | Unlimited | 2022-10-13 02:07:10+00 | 2. Physiotherapy - 30 Minute Follow Up Consult | Physiotherapy - 30 Minute Follow Up Consult | A | PHYSIOTHERAPY | Yes | 2022-10-14 03:00:00+00 | Scarb Physio & Health | NaN | NaN | Ms | QLD | 1987-02-07 | Female | 4504.0 | Narangba | Office manager | Yes | 1.0 |